package com.tedu.egmybatis3.mapper;

import com.tedu.egmybatis3.pojo.Customers;
import com.tedu.egmybatis3.pojo.CustomersVO1;
import com.tedu.egmybatis3.pojo.CustomersVO2;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface CustomersMapper {
    //在客户信息表中插入一条数据
    int insertCustomers(Customers customers);
    //根据客户编号查询某个客户的 姓名和电话
    CustomersVO1 selectCustomersNameTel(String custId);
    //查询指定城市的客户的 姓名和地址
    List<CustomersVO2> selectCustomersNameCity(String city);
}
